Database Structure

Our Store database will include the following data:

Field NameField TypeField DescrptField Width
Trans Counter Transaction Number Predefined
ItemNo Text Item Number 4
SDate Date/TimeDate Of Purchase Predefined
Descript Text Item Description 25
Dept Text Department Making Sale8
Qnty Number Quantity Predefined
Price Currency Item Price Predefined
Sale Yes/No Is Item On Sale? Predefined

Now on to creating the table!

Click


    Access displays a "New Table" window.

Click Design View

Click


    Access displays "Table" window.

Now you try it!